using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OracleClient;

using DQS.EL;

namespace DQS.DAL
{
    public static class DQ_Income_PhaseService
    {
        public static int IncomePhaseBuild(DQ_Income_Phase argIncome)
        {
            int row = 0;
            String sqlStr = "DQ_IncomePhase_P";
            OracleParameter[] _params = { 
                new OracleParameter("query_id",OracleType.Number),
                new OracleParameter("begin_date",OracleType.DateTime),
                new OracleParameter("end_date",OracleType.DateTime)
            };
            _params[0].Value = argIncome.Query_ID;
            _params[1].Value = argIncome.Begin_date;
            _params[2].Value = argIncome.End_date;
            row = OracleHelper.ExecuteNonQuery(sqlStr, CommandType.StoredProcedure, _params);
            return row;
        }
    }
}
